package com.fy.dao;

import com.fy.entity.Mu_info;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface Mu_infoMapper {
    @Select("select * from mu_info ")
    List<Mu_info> findAll();

    @Insert("insert into mu_info(mu_id, mu_pic, mu_name, mu_add, mu_info) values (#{mu_id},#{mu_pic},#{mu_name},#{mu_add},#{mu_info})")
    int insert(@Param("mu_id") String mu_id, @Param("mu_pic") String mu_pic,
               @Param("mu_name") String name, @Param("mu_add") String mu_add,
               @Param("mu_info") String mu_info);

    @Update("update mu_info set mu_pic=#{mu_pic},mu_name=#{mu_name},mu_add=#{mu_add},mu_info=#{mu_info} where mu_id=#{mu_id}")
    int updateinfo(@Param("mu_pic") String mu_pic, @Param("mu_name") String mu_name,
                   @Param("mu_add") String mu_add, @Param("mu_info") String mu_info,
                   @Param("mu_id") String mu_id);
}
